This Project not only sustained “National Environment Quality Real-time Information Service Platform” and extended subjects like environment quality data system functions and benefit, plan air, water, waste and poison chemical for on-line analysis as well as continues to expand and effectively collect the existing environment data, but also promptly provided correct and real-time environment information so that a user can conduct inquiry related to environmental protection, value-added analysis or decision support. In addition, together with the promotion of National Geographic Information System, this project extended environmental quality data warehouse to develop open environment and construct open Geographic Information System (GIS). We hope it can externally exchange with GML format as a sharing platform for environment GIS data. In the meantime, in order to achieve an internationalization exchange of environmental information, the Chinese Environment Data Warehouse System was constructed as English platform so that can be beneficial to more foreign users. This project employed OnLine Analytical Process (OLAP) to analyze the data by multiple dimensions, which can flexibly provide roll-up, drill-down and pivot. The environment quality data were integrated to analyze and extend information required by decision support, which a user can select by oneself to demonstrate time and space dimensions, cross analysis with different subjects as well as achieve the demonstration of each environment subject under appointed time and space. Therefore, data analysis and statistic calculation can be performed in large scale to further provide reference and support for decision. Constructed OLAP analysis include the performance analysis of fund donation and subsidy, statistic analysis of pollution source, analysis of monitoring data, waste and resource recycling analysis, statistic analysis of audit, statistic analysis of pollution statement and decision support analysis. In order to achieve open data sharing and reduce misunderstanding of data flow in different servers, this Project evaluated the demands of Environment Data Warehouse System and the characteristics of geographic data to establish data standard, cite or consider geographic information system standards of ISO/TC211 19100 series. The ways regulated by international standards were followed to simulate and record, so that can support international standard software for data reading and application. This project is based on “Environmental Terminology Commonly Used in the World” compiled by the Environmental Protection Administration, Executive Yuan, R. O. C. (Taiwan), assisted with regulations or customs promulgated by related organizations. For more information, please refer to Chinese webpage of Environment Data Warehouse System to establish English platform. The functions include static warehouse webpage, dynamic inquiry, OLAP analysis and dynamic form. Meanwhile, environment treaties and regulations of major countries and cities in the world as well as important issues on environmental protection for international environment organizations were brought into the system contents. In addition to existing residence information network provided by the Environmental Protection Administration, Executive Yuan, R. O. C. (Taiwan), routine maintenance and new function of GIS and environment quality data warehouse system, this project planned the mechanism of follow-up maintenance management for OLAP and geographic data. The operation contents included system function change, abnormal elimination, coordination of record modification; follow-up telephone consultation service, technical consultation and support maintenance were provided; data expansion, GIS figure layer and land information system were maintained; multiple functions were completed, including advanced services like map display, time and space analysis and spatial statistics to achieve the mechanism of routine maintenance, operation and modification for data warehouse.

Data Warehouse, On Line Analytical Processing(OLAP), Geography Markup Language (GML)